﻿CREATE TABLE [dbo].[tbl_region] (
    [id]             INT           NOT NULL,
    [id_country]     INT           NOT NULL,
    [oid]            INT           NOT NULL,
    [region_name_ru] VARCHAR (255) NULL,
    [region_name_en] VARCHAR (255) NOT NULL,
    CONSTRAINT [PK_tbl_region] PRIMARY KEY CLUSTERED ([id] ASC),
    CONSTRAINT [FK__tbl_regio__id_co__2E1BDC42] FOREIGN KEY ([id_country]) REFERENCES [dbo].[tbl_country] ([id])
);


GO
CREATE NONCLUSTERED INDEX [IX_FK__tbl_regio__id_co__2E1BDC42]
    ON [dbo].[tbl_region]([id_country] ASC);

